package com.tutu.model.dao;



/**
 * @author 图图 2020/10/10
 * 用户信息表
 */
public class UserAccountTable {
    // 表名
    public  static  final  String TAB_NAME = "tab_account";
    // 用户名
    public static  final  String COL_USERNAME = "username";
    // 密码
    public static  final  String COL_USERPWD = "userpwd";
    // 环信ID
    public static  final  String COL_HXID = "hxid";
    // 用户昵称
    public static  final  String COL_NICK = "nick";
    // 用户头像
    public static  final String COL_PHOTO = "photo";
    // 用户手机号
    public static  final  String COL_PHONE = "phone";
    //用户邮箱
    public static  final  String COL_EMAIL = "email";
    //用户性别 0 女生 1 男生
    public static  final String COL_GENDER = "gender";
    //用户真实姓名
    public static  final String COL_REALNAME = "realname";

    //创建表：注意要保证SQL语句正确注意有空格，不然程序出现闪退的情况
    public static  final String CREATE_TAB = "create table "
            + TAB_NAME     + " ("

            + COL_HXID     + " text primary key NOT NULL,"
            + COL_USERNAME + " text NOT NULL,"
            + COL_USERPWD  + " text NOT NULL,"
            + COL_NICK     + " text,"
            + COL_PHOTO    + " text,"
            + COL_PHONE    + " text,"
            + COL_EMAIL    + " text,"
            + COL_GENDER   + " INTEGER default 1,"
            + COL_REALNAME + " text"

            + ");";
}
